{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Input og resultat","IDF","Kommuneliste","Tables","help1","help3"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":45,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Input og resultat","index":0,"n_rows":54,"n_cols":14,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,11,0,13],[1,11,1,13],[2,11,2,13]]}
["Nedbørskarakteristika",null,null,null,null,null,null,null,"Pil ikke - intern beregning",null,null,"Jord- og nedsivningskarakteristika"]
["Kommune","Solrød",null,null,null,null,null,null,"Afskærende lednings kapacitet l/s",40,null,"Ved indtastning af og beregning af K-værdi, benyttes en af to følgende metoder;"]
[null," ",null,null,null,null,null,null,"Volumen m³",{"$f":"IDF!M15","v":0.11813981038349158},null,"Hvis nedsivningstest benyttes, skal K-indtastet sættes til 1, benyttes k-indtastet skal synketest sættes til 500 cm og 0,05 min"]
["Designkarakteristika",null,null,null,null,null,null,null,"Total opland (m²)",1000,null,"Nedsivningstest"]
["Gentagelsesperiode (år)",5,"år",null,null,null,null,null,null,null,null,"Vandet er sunket antal cm",40,"cm"]
["Sikkerhedsfaktor (klima, fremtidig udbygning, etc)",1.25,null,null,null,"Beregningstjek","Vol m³","Dræn kap l/s","Iterationsafstand","Antal iterationer",null,"på antal minutter",5,"min"]
["Oplandskarakteristika",null,null,null,"Faskine",{"$f":"IF(ABS((H7-B20)/H7)<0.001,\"OK\",\"Beregn\")","v":"OK"},2.1482310563015954,1.0384934061923432,8.7653349995354003E-4,21,null,"K (Hydraulisk  ledningsevne) udregnet",{"$f":"((M5/100)/(M6*60))","v":1.3333333333333335E-3},"m/s"]
["Befæstet areal (m²)",172,"m²",null,"Regnbed",{"$f":"IF(ABS((H8-B26)/H8)<0.001,\"OK\",\"Beregn\")","v":"OK"},2.718894822840193,0.8,0,1]
[null,null,null,null,"Grøft",{"$f":"IF(ABS((H9-B35)/H9)<0.001,\"OK\",\"Beregn\")","v":"OK"},1.6708656930554293,2.5054787882314655,3.9343658385587096E-5,2]
["Jord- og nedsivningskarakteristika ",null,null,null,"Perm. bel.",{"$f":"IF(ABS((H10-B44)/H10)<0.001,\"OK\",\"Beregn\")","v":"OK"},0.11813981038349158,40,0,1,null,"K (Hydraulisk  ledningsevne) indtastet",1E-4,"m/s"]
["K (Hydraulisk  ledningsevne) - se evt måling nederst ",{"$f":"MIN(M7,M10)","v":1E-4},"m/s"]
[]
[]
["Faskine",null,null,null,"Hjælpestørrelser, faskine",null,null,null,"Dimensionerende kasseregn, Afløbsteknik s. 269"]
["Bredde",0.5,"m",null,"Opstuvningsvolumen",null,{"$f":"F_bredde*F_hojde*F_hulrum*F_laengde","v":2.1482310563015954}," [m³]","Vr,k (mm)",10.408096203011604]
["Højde",0.4,"m",null,"Faskine volumen ",null,{"$f":"G15/F_hulrum","v":2.2612958487385217}," [m³]","Varighed (h)",0.25190891670608057]
["Hulrums andel i faskine [Plast: 0,95, sten: 0,25]",0.95,"0-1",null,"Regn, der holdes umiddelbart",null,{"$f":"G15/B8*1000","v":12.489715443613926}," [mm]"]
["Udsivning i faskinebund: 0=Nej ,1=ja",1,null,null,"Regn, der siver pr døgn ",null,{"$f":"B20*86400/B8","v":521.204549993917}," [mm/døgn]","Karakteritika for dimensionerende kasseregn"]
["Længde faskine",{"$f":"G7/(B15*B16*B17)","v":11.306479243692607},"m",null,"Tømmetid",{"$f":"ROUND(G19/60/60,0)","v":1},{"$f":"G15/(B20/1000)","v":2070.4182539097897}," [s]","Samlet nedbør (mm)",{"$f":"J15+G18/24*J16","v":15.87876593514693}]
["Dræn kapacitet, gennemsnit",{"$f":"((B19+B15)*B16+B18*B19*B15)*B11*1000","v":1.0375831319323348},"l/s",null,"Afløbstal ",null,{"$f":"B20/B8*10000","v":60.324600693740393},"[l/sek/ha]","Intensitet (l/sek/ha)",{"$f":"J19*10000/(J16*3600)","v":175.09377488471114}]
[]
[]
["Regnbed",null,null,null,"Hjælpestørrelser, regnbed",null,null,null,"Dimensionerende kasseregn, Afløbsteknik s. 269"]
["Areal regnbed",8,"m²",null,"Opstuvningsvolumen",null,{"$f":"R_dybde*B24","v":2.718894822840193}," [m³]","Vr,k (mm)",12.587476031667562]
["Dybde",{"$f":"G8/R_areal","v":0.33986185285502413},"m",null,"Regn, der holdes umiddelbart",null,{"$f":"G24/R_sam_opland*1000","v":15.104971238001072}," [mm]","Varighed (h)",0.3628229055118381]
["Dræn kapacitet",{"$f":"B24*B11*1000","v":0.8},"l/s",null,"Regn, der siver pr døgn ",null,{"$f":"B26*86400/R_sam_opland","v":384}," [mm/døgn]","Karakteritika for dimensionerende kasseregn"]
["Samlet opland (befæstet areal + eget areal)",{"$f":"B8+B24","v":180},"m²",null,"Tømmetid",{"$f":"ROUND(G27/60/60,0)","v":1},{"$f":"G24/(B26/1000)","v":3398.6185285502411}," [s]","Samlet nedbør (mm)",{"$f":"J24+G26/24*J25","v":18.39264251985697}]
[null,null,null,null,"Afløbstal ",null,{"$f":"R_draenkapacitet/R_sam_opland*10000","v":44.444444444444443},"[l/sek/ha]","Intensitet (l/sek/ha)",{"$f":"J27*10000/(J25*3600)","v":140.81435568185864}]
[]
[]
["Grøft / wadi, V-formet ",null,null,null,"Hjælpestørrelser, grøft",null,null,null,"Dimensionerende kasseregn, Afløbsteknik s. 269"]
["Bredde (kronekant)",2,"m",null,"Opstuvningsvolumen",null,{"$f":"0.5*B32*B34*B33","v":1.6708656930554293}," [m³]","Vr,k (mm)",6.2720183673251846]
["Længde grøft",25,"m",null,"Regn, der holdes umiddelbart",null,{"$f":"G32/B36*1000","v":7.526422040790222}," [mm]","Varighed (h)",0.12306721538554642]
["Dybde",{"$f":"(G9*2)/(G_bredde*G_Laengde)","v":6.6834627722217169E-2},"m",null,"Regn, der siver pr døgn ",null,{"$f":"G32/(G35/86400)/G_sam_opl*1000","v":975.14362233068175}," [mm/døgn]","Karakteritika for dimensionerende kasseregn"]
["Dræn kapacitet, gns-snit",{"$f":"G32/G35*1000","v":2.505577362933002},"l/s",null,"Tømmetid",{"$f":"ROUND(G35/60/60,0)","v":0},{"$f":"G_bredde/(2*B11*SQRT(1+(G_bredde/(2*G_dybde))^2))","v":666.85855235359088}," [s]","Samlet nedbør (mm)",{"$f":"J32+G34/24*J33","v":11.27236045904235}]
["Samlet opland (befæstet areal + eget areal)",{"$f":"B8+G_Laengde*G_bredde","v":222},"m²",null,"Afløbstal ",null,{"$f":"G_draenkapacitet/G_sam_opl*10000","v":112.86384517716226},"[l/sek/ha]","Intensitet (l/sek/ha)",{"$f":"J35*10000/(J33*3600)","v":254.43098137984023}]
[]
[]
["Permeabel belægning",null,null,null,"Hjælpestørrelser, perm. belægning",null,null,null,"Dimensionerende kasseregn, Afløbsteknik s. 269"]
["Areal af permeabel belægning ",400,"m²",null,"Opstuvningsvolumen",null,{"$f":"P_belaegning*B43*B42/1000","v":0.11813981038349158}," [m³]","Vr,k (mm)",9.8449841986242972E-2]
["Areal af tilstødende afvandingsareal (tag, vej, etc)",600,"m²",null,"Belægningsvolumen",null,{"$f":"P_belaegning*B43/1000","v":0.39379936794497195}," [m³]","Varighed (h)",2.9278694416444002E-2]
["Hulrumsandel af lag under belægning [0-1]",0.3,"0-1",null,"Regn, der holdes umiddelbart",null,{"$f":"G40/(P_belaegning+P_tilst_areal)*1000","v":0.11813981038349158}," [mm]"]
["Dybde af lag under belægning",0.98449841986242981,"mm",null,"Regn, der siver pr døgn ",null,{"$f":"G40/(G44/86400)/(P_belaegning+P_tilst_areal)*1000","v":3455.9999999999995}," [mm/døgn]","Karakteritika for dimensionerende kasseregn"]
["Dræn kapacitet",{"$f":"B40*B11*1000","v":40},"l/s",null,"Tømmetid",{"$f":"ROUND(G44/60/60,0)","v":0},{"$f":"G40/(B44/1000)","v":2.9534952595872896}," [s]","Samlet nedbør (mm)",{"$f":"J40+G43/24*J41","v":4.3145818379541785}]
[null,null,null,null,"Afløbstal ",null,{"$f":"B44/(P_belaegning+P_tilst_areal)*10000","v":400},"[l/sek/ha]","Intensitet (l/sek/ha)",{"$f":"J44*10000/(J41*3600)","v":409.3402997895127}]
[]
[]
[]
["Tabelværdier for den hydrauliske ledningsevne, K. Værdierne rækker over et stort spænd og K skal måles aktuelt på stedet. "]
["Grus","1e-3 til 0,1","m/s","3.600 - 360.000"," mm/ time"]
["Sand:","1e-5 til 1e-2","m/s","36 - 36.000"," mm/ time"]
["Silt:","1e-9 til 1e-5","m/s","0,0036 - 36"," mm/ time"]
["Ren ler:","under 1,0e-9","m/s"," under 0,0036"," mm/ time"]
["Moræneler","1e-10 til 1e-6","m/s","0,00036 - 3,6"," mm/ time"]

{"sheet":"IDF","index":1,"n_rows":69,"n_cols":35,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Bassindimensionering opstrøms udløb",null,null,null,null,null,null,"Regression",null,null,null,null,null,null,null,null,null,"Sæt optimering i gang"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Oplandskarakteristika",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Initdummy"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Befæstet areal (ha)",null,null,null,{"$f":"'Input og resultat'!J4/10000","v":0.1},null,null,"Estimates, 3 parameters:",null,null,null,null,null,null,null,null,null,{"$f":"initdummy(B3,B4,B8,B9,B10,I3,I4,I5,Q3,Q4,Q5)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hydrologisk reduktionsfaktor (-)",null,null,null,1,null,null,"Alpha",{"$f":"EXP(X22/10+U7*W22/10)","v":164.01796437482628}]
["Årsmiddelnedbør [mm]",{"$f":"VLOOKUP('Input og resultat'!B2,Kommuneliste!A3:C101,2,FALSE)","v":632.98455454861198},"Fås fra kommunelisten",null,null,null,null,null,null,null,null,null,"Afskærende lednings kapacitet (l/s)",null,null,null,{"$f":"'Input og resultat'!J2","v":40},null,null,"Theta",{"$f":"AD11","v":4.6032724076538081},null,null,null,null,null,null,null,null,"idftheta","theta"]
["Middelværdi Klimagrid [mm/dag]",{"$f":"VLOOKUP('Input og resultat'!B2,Kommuneliste!A3:C101,3,FALSE)","v":28.074318438083001},"Fås fra kommunelisten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nu",{"$f":"-(Z22-W22*X22/10)/(Y22-W22^2/10)","v":0.75026682346518547},null,null,null,null,null,null,null,null,{"$f":"idftheta(AE7)","v":0.10891390193970893},1]
["Gentagelsesperiode (år)",{"$f":"'Input og resultat'!B5","v":5},{"$f":"IF(B8<1/help1!C11,CONCATENATE(\" Fejl: Indtast gentagelsesperiode > \",ROUND(1/help1!C11,2),\" år\"),\" \")","v":" "},null,null,null,null,null,null,null,null,null,"NB. Frekvens- og sikkerhedsfaktorer på regnen ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"derividf","x"]
["Sikkerhedsfaktor (Fra Skrift 27)",{"$f":"'Input og resultat'!B6","v":1.25},"Defineret i Skrift 27, Faktor til beskrivelse af usikkerhed, klima, mv. Typisk 1.0 - 1.8",null,null,null,null,null,null,null,null,null,"indgår ved beregning af bassinvolumen",null,null,null,null,null,null,"Dur (min)","Intensity","ln(dur)","ln(dur+Theta)","ln(int)","ln(dur+Theta)^2","ln(dur+Theta)*ln(int)","Est. Intensity","Obj.Func",null,{"$f":"derividf(AE9)","v":-8.7667667708624109E-2},{"$f":"AE7","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bisectidf","min","max","middel","tiny"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IDF!A19","v":2},{"$f":"IDF!D19","v":39.456819281517085},{"$f":"LN(T11)","v":0.69314718055994529},{"$f":"LN(T11+$U$5)","v":1.8875653454960712},{"$f":"LN(U11)","v":3.6752068912005886},{"$f":"W11^2","v":3.5629029335177029},{"$f":"W11*X11","v":6.9371931653585808},{"$f":"$U$4*(T11+$U$5)^(-$U$7)","v":39.797269517453351},{"$f":"(LN(U11)-LN(AA11))^2","v":7.3812388458234076E-5},null,{"$f":"bisectidf(AE11,AF11,AG11,AH11)","v":4.6032724076538081},0,60,{"$f":"(AE11+AF11)/2","v":30},{"$f":"AD3/100000","v":1.0000000000000001E-5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IDF!A20","v":5},{"$f":"IDF!D20","v":30.219754342064753},1.6094379124341003,2.2621039161861072,3.4084958278262705,5.1171141276245224,7.7103717604298136,30.047950064027116,3.2505810020503005E-5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IDF!A21","v":10},{"$f":"IDF!D21","v":22.320247287993542},2.3025850929940459,2.6812456411097667,3.1054942166629163,7.1890781879701242,8.326592831919033,21.940325937877983,2.9473699821267022E-4]
["Design regnkurve",null,null,null,null,null,null,null,null,null,null,null,"Volumen af bassin",null,null,null,null,null,null,{"$f":"IDF!A22","v":30},{"$f":"IDF!D22","v":11.440307260202065},3.4011973816621555,3.5439482558473276,2.4371428440002427,12.559569240123317,8.6371081312454567,11.485313821754245,1.5415959344835418E-5]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q24*Q27*12","v":0.11813981038349158},"m3",{"$f":"IF(Y27>0.1,\"ADVARSEL: Programmet har muligvis ikke optimeret korrekt\",\" \")","v":" "},null,null,null,null,{"$f":"IDF!A23","v":60},{"$f":"IDF!D23","v":7.0202384146655454},4.0943445622221004,4.1682650659707896,1.9487971796640864,17.374433660192469,8.1231032046562124,7.189811614088411,5.6967142933096347E-4]
["Varighed","zT","S{zT}","f*zT","Regression",null,null,null,null,null,null,null,"Effekten af koblede regn ER inkluderet (20 % ekstra volumen)",null,null,null,null,null,null,{"$f":"IDF!A24","v":180},{"$f":"IDF!D24","v":3.248796965691648},5.1929568508902104,5.2182090489303397,1.1782847634113223,27.22970567833848,6.148536214649706,3.2704475251136174,4.4117093440830626E-5]
["(min)","(mm/s)","(mm/s)","(mm/s)","(mm/s)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IDF!A25","v":360},{"$f":"IDF!D25","v":1.9826306480317835},5.8861040314501558,5.898809837540691,0.68442457300206283,34.79595749946683,4.0372904042791546,1.9626481173970365,1.0261550900899028E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IDF!A26","v":720},{"$f":"IDF!D26","v":1.195817120491129},6.5792512120101012,6.5856242946081816,0.1788297345482692,43.37044734973351,1.1777054444394137,1.1723385804999056,3.931969308410201E-4]
[2,{"$f":"help1!B18","v":31.565455425213671},{"$f":"help1!C18","v":1.5629627168561984},{"$f":"$B$9*B19","v":39.456819281517085},{"$f":"IDF!$U$4*(A19+IDF!$U$5)^(-IDF!$U$7)","v":39.797269517453351},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IDF!A27","v":1440},{"$f":"IDF!D27","v":0.70562640418328848},7.2723983925700466,7.2755900108832199,-0.34866935409501648,52.934210006463694,-2.5367752697548061,0.69861334408965026,9.9769962629849611E-5]
[5,{"$f":"help1!B19","v":24.175803473651804},{"$f":"help1!C19","v":1.0606085220232371},30.219754342064753,{"$f":"IDF!$U$4*(A20+IDF!$U$5)^(-IDF!$U$7)","v":30.047950064027116},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IDF!A28","v":2880},{"$f":"IDF!D28","v":0.40767044223570537},7.965545573129992,7.9671426555894698,-0.89729617059376465,63.47536209451323,-7.1488865954346679,0.41581831720479245,3.916171459620141E-4]
[10,{"$f":"help1!B20","v":17.856197830394834},{"$f":"help1!C20","v":0.64639323712167951},22.320247287993542,{"$f":"IDF!$U$4*(A21+IDF!$U$5)^(-IDF!$U$7)","v":21.940325937877983},null,null,null,null,null,null,null,"Mellemresultater svarende til Skrift 16"]
[30,{"$f":"help1!B21","v":9.152245808161652},{"$f":"help1!C21","v":0.66416788568460761},11.440307260202065,{"$f":"IDF!$U$4*(A22+IDF!$U$5)^(-IDF!$U$7)","v":11.485313821754245},null,null,null,null,null,null,null,"Dvs. at effekt af koblede regn IKKE er indkluderet",null,null,null,null,null,null,null,"Sum",null,{"$f":"SUM(W11:W20)","v":47.488504072161966},{"$f":"SUM(X11:X20)","v":15.370710505626979},267.60878077794393,{"$f":"SUM(Z11:Z20)","v":41.412239291787891},null,{"$f":"SUM(AB11:AB20)","v":2.0174592272499108E-3}]
[60,{"$f":"help1!B22","v":5.616190731732436},{"$f":"help1!C22","v":0.43001264320022736},7.0202384146655454,{"$f":"IDF!$U$4*(A23+IDF!$U$5)^(-IDF!$U$7)","v":7.189811614088411},null,null,null,null,null,null,null,"i mellemresultaterne."]
[180,{"$f":"help1!B23","v":2.5990375725533186},{"$f":"help1!C23","v":0.20824146161637164},3.248796965691648,{"$f":"IDF!$U$4*(A24+IDF!$U$5)^(-IDF!$U$7)","v":3.2704475251136174},null,null,null,null,null,null,null,"Reduceret areal (ha)",null,null,null,{"$f":"Q3*Q4","v":0.1}]
[360,{"$f":"help1!B24","v":1.5861045184254268},{"$f":"help1!C24","v":8.5430331083946695E-2},1.9826306480317835,{"$f":"IDF!$U$4*(A25+IDF!$U$5)^(-IDF!$U$7)","v":1.9626481173970365},null,null,null,null,null,null,null,"Afløbstal (mu-m/s",null,null,null,{"$f":"Q5/(Q24*10)","v":40},null,null,null,null,"Afløbstal","tr, 3 par","Vr,k 3 par","dV/dt","(dV/dt)^2",null,null,null,"dbasvol","alpha","nu","theta","t","a"]
[720,{"$f":"help1!B25","v":0.9566536963929031},{"$f":"help1!C25","v":5.1010811147466695E-2},1.195817120491129,{"$f":"IDF!$U$4*(A26+IDF!$U$5)^(-IDF!$U$7)","v":1.1723385804999056},null,null,null,null,null,null,null,"Varighed (h)",null,null,null,{"$f":"W27/60","v":2.9278694416444002E-2},null,null,null,null,"mu-m/s",1153.5315245328354,"(mm)","( … )","( … )",null,null,null,{"$f":"dbasvol(AE26,AF26,AG26,AH26,AI26)","v":-39.676755977351618},{"$f":"U4","v":164.01796437482628},{"$f":"U7","v":0.75026682346518547},{"$f":"AE7","v":1},638,{"$f":"V27","v":40}]
[1440,{"$f":"help1!B26","v":0.56450112334663083},{"$f":"help1!C26","v":3.2376634047792889E-2},0.70562640418328848,{"$f":"IDF!$U$4*(A27+IDF!$U$5)^(-IDF!$U$7)","v":0.69861334408965026},null,null,null,null,null,null,null,"Vr,k (mm)",null,null,null,{"$f":"X27","v":9.8449841986242972E-2},null,null,"Faktisk opland",null,{"$f":"Q25","v":40},{"$f":"AD28","v":1.7567216649866402},{"$f":"(U$4*(W27+U$5)^(-U$7)-V27)*W27*60/1000","v":9.8449841986242972E-2},{"$f":"$U$4*(W27+$U$5)^(-1-$U$7)*(W27+$U$5-$U$7*W27)-V27","v":-7.5489119157794917},{"$f":"SQRT(Y27^2)","v":7.5489119157794917},null,null,null,"bisectvol","xl","xr","xmid","tiny"]
[2880,{"$f":"help1!B27","v":0.32613635378856431},{"$f":"help1!C27","v":1.8536964480259967E-2},0.40767044223570537,{"$f":"IDF!$U$4*(A28+IDF!$U$5)^(-IDF!$U$7)","v":0.41581831720479245},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Initialisering",null,null,{"$f":"(U$4*(1-U$7)/V27)^(1/U$7)","v":1.0321401420819343},null,null,null,null,null,null,{"$f":"bisectvol(AE28,AF28,AG28,AH28,AE26,AF26,AG26,AI26)","v":1.7567216649866402},{"$f":"0.3*W28","v":0.30964204262458028},{"$f":"3*W28","v":3.0964204262458028},{"$f":"(AE28+AF28)/2","v":1.7030312344351914},{"$f":"AD3/100000","v":1.0000000000000001E-5}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tilnærmet volumenkurve excl koblede regn. Tilnærmelsen er god op til ca. T=5 år"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Volumenkurve",null,0.01,{"$f":"(U$4*(1-U$7)/V31)^(1/U$7)","v":65279.569907876234},{"$f":"(U$4*(W31+U$5)^(-U$7)-V31)*W31*60/1000","v":117.66232127114731}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tilnærmet for store afløbstal",null,{"$f":"V31*1.2","v":1.2E-2},51196.448640172574,110.73190871777798]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.44E-2,40151.556713145408,104.20914748691695]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.728E-2,31489.440172299823,98.069948163769254]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.0736000000000001E-2,24696.049755904154,92.291622641053365]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.4883200000000001E-2,19368.234881565098,86.852798193136337]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.9859839999999999E-2,15189.818863148019,81.733335934905611]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5831808E-2,11912.83555296303,76.914253276378005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.2998169599999997E-2,9342.8139065068881,72.377649982983826]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.1597803519999992E-2,7327.2371891264665,68.106637446813082]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.1917364223999988E-2,5746.4919416115035,64.085270765978933]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.4300837068799988E-2,4506.769575306027,60.29848321799237]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.916100448255998E-2,3534.4993452141239,56.732022699515277]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,3033.3193476967608,54.594663013412088]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.12,2378.9246530385353,51.358570156247211]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.14399999999999999,1865.7061311832158,48.308764898638643]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.17279999999999998,1463.2070685755561,45.433436987983889]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.20735999999999996,1147.5413462739093,42.721309275985931]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.24883199999999994,899.97592937416732,40.161576958068601]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.29859839999999993,705.81916379992856,37.743846115282217]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35831807999999993,553.54890695094457,35.458071554172641]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.42998169599999991,434.12875153024635,33.29449432517309]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.51597803519999985,340.4717641722533,31.243579916363625]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.61917364223999982,267.01991469111408,29.295959069641714]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.74300837068799974,209.41423737440289,27.442374581345401]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,140.94802214683983,24.60004395411093]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,110.54052878960469,22.949999505940976]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.44,86.693011501469854,21.360920872758975]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.728,67.990250503494764,19.823970148659619]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.0735999999999999,53.322339176665807,18.33067220759418]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.4883199999999999,41.818817171812611,16.873202181832177]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.9859839999999997,32.797013346608431,15.444800653268025]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5831807999999996,25.721532965371271,14.040321909364087]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.2998169599999994,20.172484948453292,12.65689045060298]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V64*1.2","v":5.1597803519999994},15.820563632168456,11.294593102199107]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V65*1.2","v":6.1917364223999991},12.407506277935379,9.9570737945466128]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V66*1.2","v":7.4300837068799988},9.7307665906404335,8.6518434679655094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V67*1.2","v":8.9161004482559978},7.6314947033240728,7.3901006560263349]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,6.5493746849275247,6.6246784758817112]

{"sheet":"Kommuneliste","index":2,"n_rows":101,"n_cols":6,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
[null,"Årsmiddelnedbør","Middelværdi Klimagrid","Northing","Easting","Faskinebund"]
["Kommuner","mm","mm/dag","m","m","Nej/ja"]
["Albertslund",640.93120613344104,27.883887816645199,6175140,710791,0]
["Allerød",685.90148109916402,27.980664954474399,6195096,707641,1]
["Assens",715.00320983031304,25.8390130749906,6126050,565439]
["Ballerup",658.35836399584298,28.203187564974399,6181137,710019]
["Billund",888.55226207130499,26.431787823322999,6177641,498323]
["Bornholm",694.85653734071695,28.977950787728101,6126753,877619]
["Brøndby",637.69404606863304,27.704196220811799,6171287,714637]
["Brønderslev",756.59296932385598,27.067365368482601,6340900,565980]
["Christiansø",575.92674548849095,29.351724032698002,6148265,892218]
["Dragør",608.69892604858796,26.9475763886701,6164631,729202]
["Egedal",640.48044867487999,28.322975651501402,6184288,702479]
["Esbjerg",836.22271448582501,25.106513539742998,6140331,475667]
["Fanø",806.00790372292499,25.148578761261501,6140167,463990]
["Favrskov",670.50951171173097,24.9798061927643,6241884,558870]
["Faxe",650.68927764681098,26.784458755737699,6128922,694309]
["Fredensborg",722.50273138104399,27.484682690605101,6205785,715168]
["Fredericia",745.09731787026499,24.8424444364599,6158304,544664]
["Frederiksberg",639.26087634107103,26.930061600356002,6176349,721564]
["Frederikshavn",748.118980697501,27.293217834472902,6369756,584876]
["Frederikssund",645.09429524041502,27.7615068520813,6190689,690472]
["Furesø",681.251538803887,28.166383059245799,6189233,711119]
["Faaborg-Midtfyn",745.53943441181002,26.3664898891824,6115016,586719]
["Gentofte",668.62250798029095,27.507357870781401,6184154,722879]
["Gladsaxe",679.72623638416599,28.122859292174098,6183289,717732]
["Glostrup",645.51992551232001,27.729401370184199,6176147,713767]
["Greve",624.17897072648998,28.909395503067401,6165017,704840]
["Gribskov",690.75788372499801,28.391984702744299,6216274,700025]
["Guldborgsund",636.32357036614496,25.418483730899901,6072506,683158]
["Haderslev",841.32719277756496,24.977666344814299,6123036,521151]
["Halsnæs",659.18675445029498,28.521069588601001,6214464,680603]
["Hedensted",741.75545505869195,24.347441915804598,6183658,546660]
["Helsingør",691.13103251184498,28.575369709150099,6215578,718490]
["Herlev",674.63807605992497,28.1698392098236,6181717,715090]
["Herning",922.49671160917899,24.879885663672901,6222360,488223]
["Hillerød",717.47985079201396,28.012144220021099,6202533,702286]
["Hjørring",745.51069909882904,26.881341437176498,6369341,563173]
["Holbæk",645.62885618214796,27.4428681919693,6171549,664158]
["Holstebro",854.74653504369496,25.676488237905001,6250265,472585]
["Horsens",718.45225920308201,24.869681610444701,6195972,557305]
["Hvidovre",633.28187934501102,27.511905145030401,6170614,718180]
["Høje-Taastrup",631.24974368368703,27.963618121788201,6172586,704380]
["Hørsholm",710.41002173369998,27.6792280804552,6198682,717692]
["Ikast-Brande",842.23723884771505,25.907605612767799,6211985,516252]
["Ishøj",627.97511443979499,28.284516665704,6168424,708158]
["Jammerbugt",749.31674855434005,25.736466175660698,6337636,528838]
["Kalundborg",583.10702311312798,26.306944438464999,6173653,636338]
["Kerteminde",598.88593585085005,26.190674952595099,6148437,603683]
["Kolding",827.75652684753095,25.475743367253799,6147082,528789]
["København",633.10194008929898,26.458096006797,6175328,725775]
["Køge",642.28339729099298,27.417972913882998,6149215,694171]
["Langeland",610.27445594451206,27.894614769185701,6089983,611537]
["Lejre",643.94598970404797,27.260179943640601,6169481,684300]
["Lemvig",846.97458918736504,25.940693341414399,6265191,458064]
["Lolland",604.16264856124201,27.771258009738101,6077106,646894]
["Lyngby-Taarbæk",682.51325404467605,27.784908365893799,6187757,719786]
["Læsø",668.94824916902098,28.400295096767,6349069,622309]
["Mariagerfjord",740.59145543458396,26.119428329308001,6285038,557124]
["Middelfart",693.24049180281702,25.360802531533398,6144855,555348]
["Morsø",793.02187166387,25.6292930280182,6298092,485072]
["Norddjurs",649.707408549805,27.331217491238998,6265684,619069]
["Nordfyns",626.90747056583098,25.542383899057999,6153932,580292]
["Nyborg",668.44266114255095,26.701360491101202,6129361,607638]
["Næstved",645.05909460805401,25.6827459680526,6127462,674417]
["Odder",656.912019248516,25.007014429600101,6198964,577358]
["Odense",687.03326980476902,25.280920783289002,6138435,587298]
["Odsherred",628.53895517846195,27.7358049478696,6194279,658209]
["Randers",684.31447644456398,25.692089291762802,6266926,565781]
["Rebild",776.14451468312802,26.326018668349999,6296559,553453]
["Ringkøbing-Skjern",870.82498673426505,25.535033155634501,6208221,467531]
["Ringsted",665.06658455777301,27.7913453631081,6149417,677660]
["Roskilde",638.19519336601502,27.573034568640001,6171202,695850]
["Rudersdal",705.31886902110398,27.710273097552701,6193254,718461]
["Rødovre",646.26804868950296,27.6564823929446,6176969,717002]
["Samsø",567.85412622437798,25.594857308305301,6194234,603482]
["Silkeborg",783.11021370278195,25.404784542654699,6226357,533715]
["Skanderborg",736.20142978938804,24.686680140952099,6215944,553758]
["Skive",779.69903389893796,25.323961403349202,6280378,499080]
["Slagelse",581.13214535443001,26.087604991581401,6133333,641892]
["Solrød",632.98455454861198,28.074318438083001,6159241,700281]
["Sorø",654.65617413453901,26.7895706028274,6150817,658922]
["Stevns",627.19791716507802,28.043769763909399,6136582,708161]
["Struer",823.77041850242301,26.591505994569101,6266307,472360]
["Svendborg",725.83377048767397,26.5506545255475,6105259,603707]
["Syddjurs",653.056405981995,26.273019798533799,6237302,593128]
["Sønderborg",712.89087985263598,25.555349708712601,6090474,549254]
["Thisted",809.17043408193604,25.010100488009499,6307888,478660]
["Tønder",839.16397936923295,25.1340626561846,6101761,490764]
["Tårnby",613.64647722386701,26.782663043272301,6170134,730909]
["Vallensbæk",633.85668053010795,27.811915321835802,6170407,712354]
["Varde",893.33792139905495,25.8355823063964,6168689,467933]
["Vejen",926.61732497018795,25.767191982890999,6145805,502091]
["Vejle",832.65265728877398,24.670934284182302,6179553,525431]
["Vesthimmerlands",735.96088064697699,26.230677990563301,6298903,522297]
["Viborg",744.139937462445,25.199780462895099,6256251,523745]
["Vordingborg",629.147006046559,25.786341450334302,6100860,697314]
["Ærø",598.27763135131897,26.816652613032801,6083782,588196]
["Aabenraa",877.20593534373802,25.316322927456198,6093028,520451]
["Aalborg",715.75037541089898,28.1006107724434,6320099,554145]
["Aarhus",699.03280980948102,25.3702243586843,6224795,572535]

{"sheet":"Tables","index":3,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
["LAMBDA"]
[]
["Variabel","b_0","b_1","V(b_0)","Cov","V(b_1)","Res.var.",null,"E(lambda)","V(lambda)",null,"z_0"]
["i1m",0.41959999999999997,5.8669999999999998E-3,1.018,-1.4239999999999999E-3,2.052E-6,0.25850000000000001,null,{"$f":"B4+C4*IDF!$B$5","v":4.1333203815367066},{"$f":"D4+2*E4*IDF!$B$5+F4*IDF!$B$5^2+G4","v":0.29593369244721229},null,16.7]
["i2m",0.82350000000000001,3.5630000000000002E-3,0.47949999999999998,-6.5200000000000002E-4,9.3379999999999996E-7,7.1230000000000002E-2,null,{"$f":"B5+C5*IDF!$B$5","v":3.0788239678567049},{"$f":"D5+2*E5*IDF!$B$5+F5*IDF!$B$5^2+G5","v":9.9463269820846342E-2},null,14.9]
["i5m",1.476,2.3579999999999999E-3,0.42599999999999999,-5.7839999999999996E-4,8.2880000000000001E-7,5.9540000000000003E-2,null,{"$f":"B6+C6*IDF!$B$5","v":2.9685775796256268},{"$f":"D6+2*E6*IDF!$B$5+F6*IDF!$B$5^2+G6","v":8.53783043892061E-2},null,10.6]
["i10m",1.849,1.6169999999999999E-3,0.48909999999999998,-6.7159999999999995E-4,9.6059999999999996E-7,7.8719999999999998E-2,null,{"$f":"B7+C7*IDF!$B$5","v":2.8725360247051057},{"$f":"D7+2*E7*IDF!$B$5+F7*IDF!$B$5^2+G7","v":0.10247821644330322},null,7.34]
["i30m",1.825,1.6080000000000001E-3,0.42620000000000002,-5.7779999999999995E-4,8.2529999999999996E-7,5.4339999999999999E-2,null,{"$f":"B8+C8*IDF!$B$5","v":2.8428391637141681},{"$f":"D8+2*E8*IDF!$B$5+F8*IDF!$B$5^2+G8","v":7.9735542792624681E-2},null,3.74]
["i60m",2.0720000000000001,1.2160000000000001E-3,0.51719999999999999,-7.0540000000000002E-4,1.0049999999999999E-6,7.3260000000000006E-2,null,{"$f":"B9+C9*IDF!$B$5","v":2.8417092183311121},{"$f":"D9+2*E9*IDF!$B$5+F9*IDF!$B$5^2+G9","v":0.10011818397140844},null,2.39]
["i3h",1.1970000000000001,2.4870000000000001E-3,0.63429999999999997,-8.7089999999999997E-4,1.238E-6,9.6589999999999995E-2,null,{"$f":"B10+C10*IDF!$B$5","v":2.7712325871623982},{"$f":"D10+2*E10*IDF!$B$5+F10*IDF!$B$5^2+G10","v":0.12438627740304335},null,1.19]
["i6h",6.1269999999999998E-2,4.1479999999999998E-3,0.77590000000000003,-1.07E-3,1.522E-6,0.13669999999999999,null,{"$f":"B11+C11*IDF!$B$5","v":2.6868899322676425},{"$f":"D11+2*E11*IDF!$B$5+F11*IDF!$B$5^2+G11","v":0.16783195053016381},null,0.753]
["i12h",-1.19,5.986E-3,0.72199999999999998,-9.8970000000000004E-4,1.407E-6,0.1183,null,{"$f":"B12+C12*IDF!$B$5","v":2.5990455435279913},{"$f":"D12+2*E12*IDF!$B$5+F12*IDF!$B$5^2+G12","v":0.15111228366650381},null,0.45300000000000001]
["i24h",-2.3260000000000001,7.5890000000000003E-3,0.66320000000000001,-9.0609999999999996E-4,1.288E-6,0.1028,null,{"$f":"B13+C13*IDF!$B$5","v":2.4777197844694165},{"$f":"D13+2*E13*IDF!$B$5+F13*IDF!$B$5^2+G13","v":0.13496763707767634},null,0.26700000000000002]
["i48h",-3.6629999999999998,9.5809999999999992E-3,0.48449999999999999,-6.5379999999999995E-4,9.3030000000000001E-7,5.6930000000000001E-2,null,{"$f":"B14+C14*IDF!$B$5","v":2.4016250171302507},{"$f":"D14+2*E14*IDF!$B$5+F14*IDF!$B$5^2+G14","v":8.648218236243152E-2},null,0.16]
[]
[]
["MEAN"]
[]
["Variabel","b_0","b_1","V(b_0)","Cov","V(b_1)","Res.var.",null,"E(Mean)","V(Mean)"]
["i1m",5.3940000000000001,0,1.7299999999999999E-2,0,0,0.16270000000000001,null,{"$f":"B20+C20*IDF!$B$6","v":5.3940000000000001},{"$f":"D20+2*E20*IDF!$B$6+F20*IDF!$B$6^2+G20","v":0.18000000000000002}]
["i2m",5.6879999999999997,0,1.993E-2,0,0,0.1691,null,{"$f":"B21+C21*IDF!$B$6","v":5.6879999999999997},{"$f":"D21+2*E21*IDF!$B$6+F21*IDF!$B$6^2+G21","v":0.18903}]
["i5m",4.7910000000000004,0,1.2760000000000001E-2,0,0,6.9800000000000001E-2,null,{"$f":"B22+C22*IDF!$B$6","v":4.7910000000000004},{"$f":"D22+2*E22*IDF!$B$6+F22*IDF!$B$6^2+G22","v":8.2559999999999995E-2}]
["i10m",3.8769999999999998,0,7.3029999999999996E-3,0,0,1.0370000000000001E-2,null,{"$f":"B23+C23*IDF!$B$6","v":3.8769999999999998},{"$f":"D23+2*E23*IDF!$B$6+F23*IDF!$B$6^2+G23","v":1.7673000000000001E-2}]
["i30m",1.9510000000000001,0,2.552E-3,0,0,1.057E-2,null,{"$f":"B24+C24*IDF!$B$6","v":1.9510000000000001},{"$f":"D24+2*E24*IDF!$B$6+F24*IDF!$B$6^2+G24","v":1.3122E-2}]
["i60m",1.163,0,1.116E-3,0,0,6.9639999999999997E-3,null,{"$f":"B25+C25*IDF!$B$6","v":1.163},{"$f":"D25+2*E25*IDF!$B$6+F25*IDF!$B$6^2+G25","v":8.0800000000000004E-3}]
["i3h",0.21179999999999999,1.0789999999999999E-2,8.5050000000000001E-2,-3.2200000000000002E-3,1.2229999999999999E-4,1.0889999999999999E-3,null,{"$f":"B26+C26*IDF!$B$6","v":0.51472189594691553},{"$f":"D26+2*E26*IDF!$B$6+F26*IDF!$B$6^2+G26","v":1.7332568685465637E-3}]
["i6h",9.7719999999999994E-3,1.064E-2,2.8889999999999999E-2,-1.0920000000000001E-3,4.1399999999999997E-5,2.2939999999999999E-4,null,{"$f":"B27+C27*IDF!$B$6","v":0.30848274818120314},{"$f":"D27+2*E27*IDF!$B$6+F27*IDF!$B$6^2+G27","v":4.3521705981024406E-4}]
["i12h",-0.1288,1.1339999999999999E-2,8.8039999999999993E-3,-3.3270000000000001E-4,1.2629999999999999E-5,3.256E-5,null,{"$f":"B28+C28*IDF!$B$6","v":0.18956277108786121},{"$f":"D28+2*E28*IDF!$B$6+F28*IDF!$B$6^2+G28","v":1.1046221458483376E-4}]
["i24h",-9.4140000000000001E-2,7.4469999999999996E-3,3.7030000000000001E-3,-1.3990000000000001E-4,5.3129999999999998E-6,4.4280000000000003E-5,null,{"$f":"B29+C29*IDF!$B$6","v":0.11492944940840411},{"$f":"D29+2*E29*IDF!$B$6+F29*IDF!$B$6^2+G29","v":7.9618862192594442E-5}]
["i48h",-7.7879999999999998E-3,2.6199999999999999E-3,1.225E-3,-4.6260000000000001E-5,1.7579999999999999E-6,1.502E-5,null,{"$f":"B30+C30*IDF!$B$6","v":6.576671430777746E-2},{"$f":"D30+2*E30*IDF!$B$6+F30*IDF!$B$6^2+G30","v":2.8182269539716226E-5}]
[]
[]
["L-CV"]
[]
[null,"L-CV",null,null,"Kappa"]
["Variabel","mean","res. var","pred. var.","mean","res.var.","pred. var."]
["i1m",0.62019999999999997,1.908E-4,2.0770000000000001E-4,-0.38761689777491126,1.2895890081734539E-3,1.4038136110986709E-3]
["i2m",0.56459999999999999,0,1.842E-5,-0.22883457314913214,0,1.8127008175339125E-4]
["i5m",0.54349999999999998,0,2.037E-5,-0.16007359705611779,0,2.334494393717262E-4]
["i10m",0.51429999999999998,0,2.1679999999999999E-5,-5.5609566400933286E-2,0,3.0987973834140802E-4]
["i30m",0.54179999999999995,3.7530000000000002E-4,4.0880000000000002E-4,-0.15430047988187501,4.3553449914132169E-3,4.7441114641346201E-3]
["i60m",0.54200000000000004,3.5609999999999998E-4,3.9389999999999998E-4,-0.15498154981549828,4.1264332808979539E-3,4.5644539998475264E-3]
["i3h",0.53979999999999995,4.684E-4,5.1570000000000001E-4,-0.14746202297147071,5.5167761911268601E-3,6.0738716519302344E-3]
["i6h",0.54079999999999995,0,4.0609999999999999E-5,-0.15088757396449681,0,4.7477326760208931E-4]
["i12h",0.53959999999999997,5.9559999999999999E-5,1.044E-4,-0.14677538917716815,7.025333169944683E-4,1.2314385207223388E-3]
["i24h",0.53369999999999995,0,5.0210000000000002E-5,-0.12628817687839589,0,6.1887282090410253E-4]
["i48h",0.51880000000000004,7.2910000000000005E-5,1.3420000000000001E-4,-7.2474942174248325E-2,1.0064384694005808E-3,1.852476239110656E-3]

{"sheet":"help1","index":4,"n_rows":27,"n_cols":23,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["Variable","i1m",null,"i2m",null,"i5m",null,"i10m",null,"i30m",null,"i60m",null,"i3h",null,"i6h",null,"i12h",null,"i24h",null,"i48h"]
[]
["q0",{"$f":"Tables!$L$4","v":16.7},null,{"$f":"Tables!$L$5","v":14.9},null,{"$f":"Tables!$L$6","v":10.6},null,{"$f":"Tables!$L$7","v":7.34},null,{"$f":"Tables!$L$8","v":3.74},null,{"$f":"Tables!$L$9","v":2.39},null,{"$f":"Tables!$L$10","v":1.19},null,{"$f":"Tables!$L$11","v":0.753},null,{"$f":"Tables!$L$12","v":0.45300000000000001},null,{"$f":"Tables!$L$13","v":0.26700000000000002},null,{"$f":"Tables!$L$14","v":0.16}]
["lambda",{"$f":"Tables!$I$4","v":4.1333203815367066},null,{"$f":"Tables!$I$5","v":3.0788239678567049},null,{"$f":"Tables!$I$6","v":2.9685775796256268},null,{"$f":"Tables!$I$7","v":2.8725360247051057},null,{"$f":"Tables!$I$8","v":2.8428391637141681},null,{"$f":"Tables!$I$9","v":2.8417092183311121},null,{"$f":"Tables!$I$10","v":2.7712325871623982},null,{"$f":"Tables!$I$11","v":2.6868899322676425},null,{"$f":"Tables!$I$12","v":2.5990455435279913},null,{"$f":"Tables!$I$13","v":2.4777197844694165},null,{"$f":"Tables!$I$14","v":2.4016250171302507}]
["mean",{"$f":"Tables!$I$20","v":5.3940000000000001},null,{"$f":"Tables!I21","v":5.6879999999999997},null,{"$f":"Tables!I22","v":4.7910000000000004},null,{"$f":"Tables!I23","v":3.8769999999999998},null,{"$f":"Tables!I24","v":1.9510000000000001},null,{"$f":"Tables!I25","v":1.163},null,{"$f":"Tables!I26","v":0.51472189594691553},null,{"$f":"Tables!I27","v":0.30848274818120314},null,{"$f":"Tables!I28","v":0.18956277108786121},null,{"$f":"Tables!I29","v":0.11492944940840411},null,{"$f":"Tables!I30","v":6.576671430777746E-2}]
["kappa",{"$f":"Tables!$E$37","v":-0.38761689777491126},null,{"$f":"Tables!$E$38","v":-0.22883457314913214},null,{"$f":"Tables!$E$39","v":-0.16007359705611779},null,{"$f":"Tables!$E$40","v":-5.5609566400933286E-2},null,{"$f":"Tables!$E$41","v":-0.15430047988187501},null,{"$f":"Tables!$E$42","v":-0.15498154981549828},null,{"$f":"Tables!$E$43","v":-0.14746202297147071},null,{"$f":"Tables!$E$44","v":-0.15088757396449681},null,{"$f":"Tables!$E$45","v":-0.14677538917716815},null,{"$f":"Tables!$E$46","v":-0.12628817687839589},null,{"$f":"Tables!$E$47","v":-7.2474942174248325E-2}]
["V_lambda",{"$f":"Tables!$J$4","v":0.29593369244721229},null,{"$f":"Tables!$J$5","v":9.9463269820846342E-2},null,{"$f":"Tables!$J$6","v":8.53783043892061E-2},null,{"$f":"Tables!$J$7","v":0.10247821644330322},null,{"$f":"Tables!$J$8","v":7.9735542792624681E-2},null,{"$f":"Tables!$J$9","v":0.10011818397140844},null,{"$f":"Tables!$J$10","v":0.12438627740304335},null,{"$f":"Tables!$J$11","v":0.16783195053016381},null,{"$f":"Tables!$J$12","v":0.15111228366650381},null,{"$f":"Tables!$J$13","v":0.13496763707767634},null,{"$f":"Tables!$J$14","v":8.648218236243152E-2}]
["V_mean",{"$f":"Tables!$J$20","v":0.18000000000000002},null,{"$f":"Tables!J21","v":0.18903},null,{"$f":"Tables!J22","v":8.2559999999999995E-2},null,{"$f":"Tables!J23","v":1.7673000000000001E-2},null,{"$f":"Tables!J24","v":1.3122E-2},null,{"$f":"Tables!J25","v":8.0800000000000004E-3},null,{"$f":"Tables!J26","v":1.7332568685465637E-3},null,{"$f":"Tables!J27","v":4.3521705981024406E-4},null,{"$f":"Tables!J28","v":1.1046221458483376E-4},null,{"$f":"Tables!J29","v":7.9618862192594442E-5},null,{"$f":"Tables!J30","v":2.8182269539716226E-5}]
["V_kappa",{"$f":"Tables!$G$37","v":1.4038136110986709E-3},null,{"$f":"Tables!$G$38","v":1.8127008175339125E-4},null,{"$f":"Tables!$G$39","v":2.334494393717262E-4},null,{"$f":"Tables!$G$40","v":3.0987973834140802E-4},null,{"$f":"Tables!$G$41","v":4.7441114641346201E-3},null,{"$f":"Tables!$G$42","v":4.5644539998475264E-3},null,{"$f":"Tables!$G$43","v":6.0738716519302344E-3},null,{"$f":"Tables!$G$44","v":4.7477326760208931E-4},null,{"$f":"Tables!$G$45","v":1.2314385207223388E-3},null,{"$f":"Tables!$G$46","v":6.1887282090410253E-4},null,{"$f":"Tables!$G$47","v":1.852476239110656E-3}]
[]
["Min Lanbda",null,{"$f":"MIN(B4:V4)","v":2.4016250171302507}]
[]
["T","z_T","S(z_T)","z_T","S(z_T)","z_T","S(z_T)","z_T","S(z_T)","z_T","S(z_T)","z_T","S(z_T)","z_T","S(z_T)","z_T","S(z_T)","z_T","S(z_T)","z_T","S(z_T)","z_T","S(z_T)"]
[{"$f":"IDF!B8","v":5},{"$f":"B$5*(1+B$6)/B$6*(1-(1/($A14*B$4))^B$6)+B$3","v":35.74281467702275},{"$f":"SQRT(((1+B$6)*B$5*$A14*(B$4*$A14)^(-B$6-1))^2*B$7+((1+B$6)/B$6*(1-(1/($A14*B$4))^B$6))^2*B$8+((1+B$6)*B$5*((B$4*$A14)^(-B$6)/B$6*LN(B$4*$A14)-1/B$6^2*(1-(B$4*$A14)^(-B$6))))^2*B$9)","v":2.4243494125562184},{"$f":"D$5*(1+D$6)/D$6*(1-(1/($A14*D$4))^D$6)+D$3","v":31.565455425213671},{"$f":"SQRT(((1+D$6)*D$5*$A14*(D$4*$A14)^(-D$6-1))^2*D$7+((1+D$6)/D$6*(1-(1/($A14*D$4))^D$6))^2*D$8+((1+D$6)*D$5*((D$4*$A14)^(-D$6)/D$6*LN(D$4*$A14)-1/D$6^2*(1-(D$4*$A14)^(-D$6))))^2*D$9)","v":1.5629627168561984},{"$f":"F$5*(1+F$6)/F$6*(1-(1/($A14*F$4))^F$6)+F$3","v":24.175803473651804},{"$f":"SQRT(((1+F$6)*F$5*$A14*(F$4*$A14)^(-F$6-1))^2*F$7+((1+F$6)/F$6*(1-(1/($A14*F$4))^F$6))^2*F$8+((1+F$6)*F$5*((F$4*$A14)^(-F$6)/F$6*LN(F$4*$A14)-1/F$6^2*(1-(F$4*$A14)^(-F$6))))^2*F$9)","v":1.0606085220232371},{"$f":"H$5*(1+H$6)/H$6*(1-(1/($A14*H$4))^H$6)+H$3","v":17.856197830394834},{"$f":"SQRT(((1+H$6)*H$5*$A14*(H$4*$A14)^(-H$6-1))^2*H$7+((1+H$6)/H$6*(1-(1/($A14*H$4))^H$6))^2*H$8+((1+H$6)*H$5*((H$4*$A14)^(-H$6)/H$6*LN(H$4*$A14)-1/H$6^2*(1-(H$4*$A14)^(-H$6))))^2*H$9)","v":0.64639323712167951},{"$f":"J$5*(1+J$6)/J$6*(1-(1/($A14*J$4))^J$6)+J$3","v":9.152245808161652},{"$f":"SQRT(((1+J$6)*J$5*$A14*(J$4*$A14)^(-J$6-1))^2*J$7+((1+J$6)/J$6*(1-(1/($A14*J$4))^J$6))^2*J$8+((1+J$6)*J$5*((J$4*$A14)^(-J$6)/J$6*LN(J$4*$A14)-1/J$6^2*(1-(J$4*$A14)^(-J$6))))^2*J$9)","v":0.66416788568460761},{"$f":"L$5*(1+L$6)/L$6*(1-(1/($A14*L$4))^L$6)+L$3","v":5.616190731732436},{"$f":"SQRT(((1+L$6)*L$5*$A14*(L$4*$A14)^(-L$6-1))^2*L$7+((1+L$6)/L$6*(1-(1/($A14*L$4))^L$6))^2*L$8+((1+L$6)*L$5*((L$4*$A14)^(-L$6)/L$6*LN(L$4*$A14)-1/L$6^2*(1-(L$4*$A14)^(-L$6))))^2*L$9)","v":0.43001264320022736},{"$f":"N$5*(1+N$6)/N$6*(1-(1/($A14*N$4))^N$6)+N$3","v":2.5990375725533186},{"$f":"SQRT(((1+N$6)*N$5*$A14*(N$4*$A14)^(-N$6-1))^2*N$7+((1+N$6)/N$6*(1-(1/($A14*N$4))^N$6))^2*N$8+((1+N$6)*N$5*((N$4*$A14)^(-N$6)/N$6*LN(N$4*$A14)-1/N$6^2*(1-(N$4*$A14)^(-N$6))))^2*N$9)","v":0.20824146161637164},{"$f":"P$5*(1+P$6)/P$6*(1-(1/($A14*P$4))^P$6)+P$3","v":1.5861045184254268},{"$f":"SQRT(((1+P$6)*P$5*$A14*(P$4*$A14)^(-P$6-1))^2*P$7+((1+P$6)/P$6*(1-(1/($A14*P$4))^P$6))^2*P$8+((1+P$6)*P$5*((P$4*$A14)^(-P$6)/P$6*LN(P$4*$A14)-1/P$6^2*(1-(P$4*$A14)^(-P$6))))^2*P$9)","v":8.5430331083946695E-2},{"$f":"R$5*(1+R$6)/R$6*(1-(1/($A14*R$4))^R$6)+R$3","v":0.9566536963929031},{"$f":"SQRT(((1+R$6)*R$5*$A14*(R$4*$A14)^(-R$6-1))^2*R$7+((1+R$6)/R$6*(1-(1/($A14*R$4))^R$6))^2*R$8+((1+R$6)*R$5*((R$4*$A14)^(-R$6)/R$6*LN(R$4*$A14)-1/R$6^2*(1-(R$4*$A14)^(-R$6))))^2*R$9)","v":5.1010811147466695E-2},{"$f":"T$5*(1+T$6)/T$6*(1-(1/($A14*T$4))^T$6)+T$3","v":0.56450112334663083},{"$f":"SQRT(((1+T$6)*T$5*$A14*(T$4*$A14)^(-T$6-1))^2*T$7+((1+T$6)/T$6*(1-(1/($A14*T$4))^T$6))^2*T$8+((1+T$6)*T$5*((T$4*$A14)^(-T$6)/T$6*LN(T$4*$A14)-1/T$6^2*(1-(T$4*$A14)^(-T$6))))^2*T$9)","v":3.2376634047792889E-2},{"$f":"V$5*(1+V$6)/V$6*(1-(1/($A14*V$4))^V$6)+V$3","v":0.32613635378856431},{"$f":"SQRT(((1+V$6)*V$5*$A14*(V$4*$A14)^(-V$6-1))^2*V$7+((1+V$6)/V$6*(1-(1/($A14*V$4))^V$6))^2*V$8+((1+V$6)*V$5*((V$4*$A14)^(-V$6)/V$6*LN(V$4*$A14)-1/V$6^2*(1-(V$4*$A14)^(-V$6))))^2*V$9)","v":1.8536964480259967E-2}]
[]
["Dur(min)","z_T","S_T"]
[1,{"$f":"B14","v":35.74281467702275},{"$f":"C14","v":2.4243494125562184}]
[2,{"$f":"D14","v":31.565455425213671},{"$f":"E14","v":1.5629627168561984}]
[5,{"$f":"F14","v":24.175803473651804},{"$f":"G14","v":1.0606085220232371}]
[10,{"$f":"H14","v":17.856197830394834},{"$f":"I14","v":0.64639323712167951}]
[30,{"$f":"J14","v":9.152245808161652},{"$f":"K14","v":0.66416788568460761}]
[60,{"$f":"L14","v":5.616190731732436},{"$f":"M14","v":0.43001264320022736}]
[180,{"$f":"N14","v":2.5990375725533186},{"$f":"O14","v":0.20824146161637164}]
[360,{"$f":"P14","v":1.5861045184254268},{"$f":"Q14","v":8.5430331083946695E-2}]
[720,{"$f":"R14","v":0.9566536963929031},{"$f":"S14","v":5.1010811147466695E-2}]
[1440,{"$f":"T14","v":0.56450112334663083},{"$f":"U14","v":3.2376634047792889E-2}]
[2880,{"$f":"V14","v":0.32613635378856431},{"$f":"W14","v":1.8536964480259967E-2}]

{"sheet":"help3","index":5,"n_rows":32,"n_cols":18,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Variable",null,"bv1","bv2",null,null,null,null,null,null,null,null,"LAMBDA"]
[]
["z0",null,{"$f":"Q4","v":17.8},{"$f":"Q5","v":6.26},null,null,null,null,null,null,null,null,"Variable","b_0","b_1",null,"z_0","E(lambda)"]
["lambda",null,{"$f":"R4","v":2.451942505335563},{"$f":"R5","v":2.8662852025137511},null,null,null,null,null,null,null,null,"bv1",-2.855,8.3840000000000008E-3,null,17.8,{"$f":"N4+O4*IDF!$B$5","v":2.451942505335563}]
["mean",null,{"$f":"Q10","v":11.6515898432206},{"$f":"Q11","v":4.9800000000000004},null,null,null,null,null,null,null,null,"bv2",1.9319999999999999,1.4760000000000001E-3,null,6.26,{"$f":"N5+O5*IDF!$B$5","v":2.8662852025137511}]
["kappa",null,{"$f":"O17","v":-0.16412704240866516},{"$f":"O18","v":-0.22127356812522248}]
[null,null,null,null,null,null,null,null,null,null,null,null,"MEAN"]
[]
[null,null,null,null,null,null,"Incl. koblede regn, f-faktor 0, s-faktor 1",null,null,null,null,null,"Variable","b_0","b_1",null,"E(mean)"]
["T =",{"$f":"IDF!B8","v":5},{"$f":"C$5*(1+C$6)/C$6*(1-(1/($B10*C$4))^C$6)+C$3","v":47.995619473952786},{"$f":"D$5*(1+D$6)/D$6*(1-(1/($B10*D$4))^D$6)+D$3","v":20.323295564282986},null,0.1,{"$f":"C10","v":47.995619473952786},null,null,null,null,null,"bv1",-11.01,0.80720000000000003,null,{"$f":"N10+O10*IDF!B6","v":11.6515898432206}]
[null,null,null,null,null,1,{"$f":"D10","v":20.323295564282986},null,null,null,null,null,"bv2",4.9800000000000004,0,null,{"$f":"N11+O11*IDF!B6","v":4.9800000000000004}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"L-CV"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kappa"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Variable","mean","mean"]
[null,null,null,null,null,null,null,null,null,null,null,null,"bv1",0.54469999999999996,{"$f":"1/N17-2","v":-0.16412704240866516}]
[null,null,null,null,null,null,null,null,null,null,null,null,"bv2",0.56220000000000003,{"$f":"1/N18-2","v":-0.22127356812522248}]
[]
[]
[]
[]
[]
[]
[]
[null,1,{"$f":"C$5*(1+C$6)/C$6*(1-(1/($B26*C$4))^C$6)+C$3","v":27.210586662338287},10.858624093458644]
[null,2,35.494162445055252,14.526063967903172]
[null,5,47.995619473952786,20.323295564282986]
[null,10,58.783539774878477,25.559620511417393]
[null,20,70.871273711575753,31.663930371777454]
[null,50,89.113913164655372,41.313195038163293]
[null,100,104.85608946006121,50.028852581610593]